[dbo].[Content_Authority

Property	Value
Created	10:31:18 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_Content_Authority_Producer: ContentAuthorityGroupID\ContactID$	ContentAuthorityGroupID	numeric(18,0)	9
$Cluster Primary Key PK_Content_Authority_Producer: ContentAuthorityGroupID\ContactID$	ContactID	numeric(18,0)	9
	ContentEditorFlag	char(1)	1
	ContentApproverFlag	char(1)	1
	NavCreatorFlag	char(1)	1
	NavEditorFlag	char(1)	1
	LayoutFlag	char(1)	1
	EditorFlag	char(1)	1
	CustomPageFlag	char(1)	1
	ComponentScriptFlag	char(1)	1
	UploadFlag	char(1)	1
	DefaultOwnerFlag	char(1)	1
	HighestToolbarLevelInd	char(1)	1	('S')

	Name	Columns	Unique
$Cluster Primary Key PK_Content_Authority_Producer: ContentAuthorityGroupID\ContactID$	PK_Content_Authority_Producer	ContentAuthorityGroupID, ContactID

Name	Columns
FK_ContentAuthorityProd_CAG	ContentAuthorityGroupID->[dbo].[Content_Authority_Group].[ContentAuthorityGroupID]
FK_ContentAuthorityProd_Prod	ContactID->[dbo].[Producer].[ContactID]

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Content_Authority_Producer]
(
[ContentAuthorityGroupID] [numeric] (18, 0) NOT NULL,
[ContactID] [numeric] (18, 0) NOT NULL,
[ContentEditorFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContentApproverFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NavCreatorFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NavEditorFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LayoutFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EditorFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomPageFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ComponentScriptFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UploadFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultOwnerFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HighestToolbarLevelInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Content_Authority_Producer_HighestToolbarLevelInd] DEFAULT ('S')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Content_Authority_Producer] ADD CONSTRAINT [PK_Content_Authority_Producer] PRIMARY KEY CLUSTERED ([ContentAuthorityGroupID], [ContactID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Content_Authority_Producer] ADD CONSTRAINT [FK_ContentAuthorityProd_CAG] FOREIGN KEY ([ContentAuthorityGroupID]) REFERENCES [dbo].[Content_Authority_Group] ([ContentAuthorityGroupID])
GO
ALTER TABLE [dbo].[Content_Authority_Producer] ADD CONSTRAINT [FK_ContentAuthorityProd_Prod] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[Producer] ([ContactID])
GO
GRANT REFERENCES ON  [dbo].[Content_Authority_Producer] TO [IMIS]
GRANT SELECT ON  [dbo].[Content_Authority_Producer] TO [IMIS]
GRANT INSERT ON  [dbo].[Content_Authority_Producer] TO [IMIS]
GRANT DELETE ON  [dbo].[Content_Authority_Producer] TO [IMIS]
GRANT UPDATE ON  [dbo].[Content_Authority_Producer] TO [IMIS]
GO